DLF VIRTUSA  2nd round 

1. Write a trigger 

2. Write a procedure using cursor and loop  

3. Write a function with ref cursor 

4.if a trigger is not fired what are the steps would you take 

5.what are the reasons you would go for bull collect and bulk bind

6. Have you used performance tuning .. 
if yes then 
Explain what all you have done

7.write a package  

8. Collection inside package??

9.how do u declare a variable in a package 

10. Write a syntax for gtt.. and explain why we use gtt 

11. Reason for job change